2013-02-15 - 5773 - Service Request - TAS and Intercompany Test Query #BWProductionIssues
SERVICE REQUEST
5773 - TAS and Intercompany test query
Problem Summary
NEC TAS Order 1297721 is not loaded into Open Order Cube.
Admin Info
Purpose
|
TAS and Intercompany test query
|
Requested by
|
Mark Harris
|
Issue Date
|
02-15-2013
|
Resolved by
|
Chandramouli K
|
Resolved Date
|
02-15-2013
|
Document Status
|
Complete
|
Detailed Problem Description
NEC reported us that TAS Order 1297721 didnot get loaded into Open Order InfoCube and hence not visible in open order reports.
Solution Analysis and Recommendations
We have logic existing in Open Order Cube transformation to delete any sales order when its billing order status is equal to ‘C’ (Completed) in Order Header status DSO. For the TAS Order 1297721 with the items 2450, 2460, 2470 and 2480 has been invoiced completely. Hence this order billing status became ‘C’(due to note below) and updated to Order Header status DSO. Finally the Order 1297721 is not updated into Open Order Cube.
Note: For a TAS Order, whenever atleast one of its item is invoiced, it will get its billing order status as ‘C’ in VBUK Table and next this is updated to BW into the Order Header status DSO.
Resolution
For TAS Orders that are partially invoiced, the Order status is updated to 'C' and as per NEC businedd requirement such orders are not loaded into open order cube and hence not visible in reports.
Release Information
None